RelationshipStage

Entity Definition

Logical Name : RelationshipStage
Physical Name : CO_RLtN_Stg

Identifies high-level phase of development of a customer relationship. Retailers may create their own values and definitions. ARTS sample values are: CUST_ACQUISITION - pre-customer (has not purchased product/services) CUSTOMER - Consumer purchased product INACTIVE_CUSTOMER - has not purchased anything in last N periods, where N is designated by the retailer EX_CUSTOMER - "Dead" customer - no anticipated reactivation

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
RelationshipStageCode (PK)	Code that identifies a partiular stage of development for customer conversion analysis. A list of proposed stages is provided in the entity definition. This code may be assigned by the retailer. ARTS recommends at least four stages: CUST_ACQUISITION CUSTOMER INACTIVE_CUSTOMER EX_CUSTOMER Retailers may define their own codes.	CD_RLTN_STG	Code	varchar(20)
RelationshipStageDescription	Short business description of the relationship stage.	DE_RLTN_STG	DescriptionShort	varchar(255)

Relationships

Parent Entity	Verb Phrase	Child Entity
RelationshipStage	includes	ConversionState

Logical Views containing RelationshipStage

Logical View
Logical 06310 - Party - Role View
Logical 07010 - Customer Account Information Extended
Logical 07015 - Customer Lifecycle and Registration
Logical 07017 - Consumer-Customer Lifecycle Context View